SELECT col7 , col0 , FIRST_VALUE(col0) OVER(PARTITION BY col7 ORDER BY col0 ) FIRST_VALUE_col0 FROM "allTypsUniq.parquet" WHERE col0 IN (2147483647,1073741823,1,-1,0,10000000,65535,-65535,13,19,29,3,7,109 )